package org.springblade.modules.enterprise.excel;

import com.alibaba.excel.annotation.ExcelProperty;
import com.alibaba.excel.annotation.write.style.ColumnWidth;
import com.alibaba.excel.annotation.write.style.ContentRowHeight;
import com.alibaba.excel.annotation.write.style.HeadRowHeight;
import com.fasterxml.jackson.annotation.JsonFormat;
import lombok.Data;

import java.io.Serializable;
import java.time.LocalDateTime;

@Data
@ColumnWidth(25)
@HeadRowHeight(20)
@ContentRowHeight(18)
public class AwardCorporateExcel implements Serializable {
	private static final long serialVersionUID = 1L;
	/**
	 * 企业名称
	 */
	@ExcelProperty("企业名称")
	private String corName;
	/**
	 * 统一社会信用代码
	 */
	@ExcelProperty("统一社会信用代码")
	private String corNumber;
	/**
	 * 法人姓名
	 */
	@ExcelProperty("法人姓名")
	private String corUserName;
	/**
	 * 身份证号
	 */
	@ExcelProperty("身份证号")
	private String corUserCardId;
	/**
	 * 手机号
	 */
	@ExcelProperty("手机号")
	private String corUserMobile;
	/**
	 * 对公银行账号
	 */
	@ExcelProperty("对公银行账号")
	private String corBankAccount;
	/**
	 * 开户行
	 */
	@ExcelProperty("开户行")
	private String openBank;
	/**
	 * 兑现事项名称
	 */
	@ExcelProperty("兑现事项名称")
	private String cashMatterName;
	/**
	 * 已（拟）享受政策兑现时间
	 */
	@ExcelProperty(value = "已（拟）享受政策兑现时间",converter = LocalDateTimeConverter.class)
	@JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8")
	private LocalDateTime policyCashTime;
	/**
	 * 兑现金额
	 */
	@ExcelProperty("兑现金额")
	private Double cashFund;
	/**
	 * 审批部门
	 */
	@ExcelProperty("审批部门")
	private String completeDeptName;
	/**
	 * 符合兑现的条件
	 */
	@ExcelProperty("符合兑现的条件")
	private String cashCondition;
	/**
	 * 备注
	 */
	@ExcelProperty("备注")
	private String remark;

	public static AwardCorporateExcel getExcelExample() {
		AwardCorporateExcel exampleAwardCorporate = new AwardCorporateExcel();
		exampleAwardCorporate.setCorName("湖北科技学院");
		exampleAwardCorporate.setCorNumber("12420000420425072Q");
		exampleAwardCorporate.setCorUserName("陈博");
		exampleAwardCorporate.setCorUserCardId("42122221323332313131");
		exampleAwardCorporate.setCorUserMobile("1599794XXXX");
		exampleAwardCorporate.setCorBankAccount("123123131313123");
		exampleAwardCorporate.setOpenBank("农行襄阳市隆中支行");
		exampleAwardCorporate.setCashMatterName("省知识产权“三大工程”项目奖励");
		exampleAwardCorporate.setPolicyCashTime(LocalDateTime.of(2022,7,25,0,0,0));
		exampleAwardCorporate.setCashFund(100000.0);
		exampleAwardCorporate.setCompleteDeptName("市场监管局");
		exampleAwardCorporate.setCashCondition("省知识产权局知识产权三大工程配套奖励-高价值培育工程高产甾体皂苷真菌高效生物合成转化技术体系及产业化");
		exampleAwardCorporate.setRemark("年无申请兑现指标台账");
		return exampleAwardCorporate;
	}
}
